
ALTER VIEW [dbo].[OTR_GetPendingFueldrop]
AS
SELECT     TOP (100) PERCENT dbo.FuelDrops.FuelDropID, dbo.FuelDrops.FuelDropType, dbo.FuelDrops.IssuerVATRegNo, dbo.FuelDrops.InvoiceTransType, dbo.FuelDrops.InvoiceTransSeries, 
                      dbo.FuelDrops.DocumentNumber,  dbo.FuelDrops.InvoiceIssueDate, dbo.FuelDrops.FuelDropComplete, dbo.FuelDrops.StoredInBO, 
                      dbo.FuelDropsGrades.GradeSeq AS LineNumber, dbo.FuelDropsGrades.GradeID, dbo.Grades.Oil_Company_Code AS GradePLU, dbo.Grades.Grade_Name, dbo.FuelDropsGrades.LoadTCVolume, 
                      dbo.FuelDropsGrades.GradeCost, dbo.FuelDropsGrades.DropTCVolume, dbo.FuelDrops.VehicleNumber, dbo.FuelDrops.DriverNameID AS DriverName, (CASE WHEN (isnull(Fueldrops.DespatchID, 0) 
<> 0) THEN
                          (SELECT     TOP 1 PlantDipethe
                            FROM          dbo.IncomingFueldrops AS IFD
                            WHERE      (DespatchID = dbo.FuelDrops.DespatchID)) ELSE Fueldrops.PlantDipethe END) AS DipethePlant,
                          (SELECT     TOP (1) Site_Number
                            FROM          dbo.Global_Settings) AS BranchNo, dbo.FuelDropsGrades.GradeInvoiceSeries, dbo.FuelDropsGrades.GradeInvoiceNumber
FROM         dbo.FuelDrops INNER JOIN
                      dbo.FuelDropsGrades ON dbo.FuelDrops.FuelDropID = dbo.FuelDropsGrades.FuelDropID INNER JOIN
                      dbo.Grades ON dbo.FuelDropsGrades.GradeID = dbo.Grades.Grade_ID
WHERE     (dbo.FuelDrops.FuelDropType = 1) AND (dbo.FuelDrops.FuelDropComplete = 1) AND (dbo.FuelDrops.StoredInBO = 0)
ORDER BY dbo.FuelDrops.FuelDropID, LineNumber
 
 

GO


